Posted to microsoft.public.excel.misc

external usenet poster

Posts: 390

Need help with a project sheet, need date to show/not show based o

Hello,

I have the following formula in cell S2
=IF(B2="","",DATE(YEAR(B2),MONTH(B2),DAY(B2)+31))
This takes a date in cell B2 and adds 31 days to it and displays it.

What I need to do is to NOT have cell S2 show any date if anything is in
cell D2.

I'm not very adept at Vis Basic if that what it will take to do it.

Thanks
Max

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Show prior year based on date in other cell	Munchkin	Excel Worksheet Functions	3	June 17th 09 07:44 PM
How to show date in H2 based on date in I2 minus set number of day	jt24	Excel Discussion (Misc queries)	2	January 9th 08 12:37 PM
Show a date based on today	DJ Dusty	Excel Worksheet Functions	2	November 12th 04 03:20 AM
Show a date based on today	DJ Dusty	Excel Worksheet Functions	0	November 11th 04 10:32 PM
Show a date based on today	DJ Dusty	Excel Worksheet Functions	1	November 11th 04 10:28 PM

All times are GMT +1. The time now is 10:06 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us