[Solved]find date and enter

ram8516 · General User Joined: 25 Apr 2010 Posts: 42

Hi

I have dates starting from feb 1 to feb 29 in cells F5 to AH5. I have appointment date in cel C16 . I want a formula to check cells F5 to AH5 for the date entered in cell C16. and enter the text "busy" in the corresponding date in F16 tp AH 16

mgroenescheij · Posted: Mon Jan 30, 2012 10:29 pm Post subject:

Hi,

Enter this formula in F16 =IF(F5=$C$16;"busy";"") and copy it to G16 t0 AH 16

Martin
_________________
If your problem has been solved please add "[Solved]" to the beginning of your first post title (edit button).

ram8516 · General User Joined: 25 Apr 2010 Posts: 42

Hi martin

thank you for the help. i got the logic but i have trouble in using the following formula instead of the text "busy"

=IF(COLUMN(D$16)-3>$D$16;"";$C$16+(COLUMN(D$16)-3)-1)

This will display the dates from a start date and total days

hope you can help

mgroenescheij · Posted: Mon Jan 30, 2012 11:45 pm Post subject:

Hi,

Can you give more details? What values are in D16 and C16?
And what do you want to achieve?

Martin
_________________
If your problem has been solved please add "[Solved]" to the beginning of your first post title (edit button).

ram8516 · General User Joined: 25 Apr 2010 Posts: 42

D16 has no of days
C16 has start date

What i want is the the formula should display the dates based on the start date and number of days from cell F16 onwards

Thanks
Regards
Ram

mgroenescheij · Posted: Tue Jan 31, 2012 3:42 am Post subject:

Hi,

The following formula will enter the Date of Row 5 in Row 16 for the same column when the start date + the elapse days are Less or equal to the date in Row 5.
When the date in Row 5 is greater than Start date plus elapse days it print the number of days. =IF($C16+$D16>=F$5;F$5;F$5-$C16-$D16)

Martin

Forgot to say that it only works if your cells are formatted as General.
_________________
If your problem has been solved please add "[Solved]" to the beginning of your first post title (edit button).