Posted to microsoft.public.excel.misc

KrisP

external usenet poster

Posts: 8

Changing cell if within 365 days?

Hi,
I need a way of changing the text in a cell if its over 365 days from a date
in a cell A1?

Example - If A1 is 01/06/2008 then cell B2 = yes. If A1 was 01/01/2000 then
B2 = no.

Thanks in advance!

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
Changing background colour when changing data in a cell	Paoul	Excel Discussion (Misc queries)	7	December 26th 08 07:25 AM
changing from days to months	ultrasounds4u1	Charts and Charting in Excel	1	July 4th 08 03:33 PM
changing weekend days	Otaibi	Setting up and Configuration of Excel	2	April 24th 07 09:52 AM
Changing working days	Greg	Excel Worksheet Functions	6	August 1st 06 12:25 PM
changing a cell to changing the link	Jared	Excel Worksheet Functions	7	May 8th 06 08:41 AM

All times are GMT +1. The time now is 11:26 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us