Posted to microsoft.public.excel.misc

Kathleen

external usenet poster

Posts: 44

date formulas

Hi, I have two problems that need help.

Cell A1 has a date of birth. Cell A2 calculates the age. If there isn't a
dob of birth, cell A2 returns 110.

Another one is having cell C1 with a date or NA. C2 is based on cell C1 and
adds 3 months to the date in C1 but if C1 has NA, the return is #value!.

Kathleen

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
date formulas	rwpatter1	Excel Worksheet Functions	3	March 26th 09 02:09 PM
Date Formulas	PhooPhan	Excel Worksheet Functions	2	January 28th 07 01:42 AM
date formulas	sunderland27	Excel Discussion (Misc queries)	2	April 24th 06 08:59 PM
Date formulas	Cachod1	New Users to Excel	1	March 28th 05 08:02 PM
Using formulas to determine date in one cell based on date in anot	Gary	Excel Worksheet Functions	2	November 22nd 04 08:11 AM

All times are GMT +1. The time now is 08:19 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us