Posted to microsoft.public.excel.worksheet.functions

Patrick C. Simonds Patrick C. Simonds is offline

external usenet poster

Posts: 343

Date issue

I need to construct a formula which will subtract 1 month from the previous
month and return the first day of the preceding month.

Example:
A1 value is 24 April, I want A2's value to be 1 March

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 issue	Jim at SDSU	Excel Worksheet Functions	3	July 28th 07 04:22 AM
Date issue	Jim Savage	Excel Discussion (Misc queries)	7	February 9th 07 03:48 PM
DATE ISSUE!	Joan	Excel Worksheet Functions	2	June 15th 06 03:39 PM
Date issue	polk383	Excel Worksheet Functions	3	June 10th 06 06:21 PM
Another Date issue.	TimM	Excel Worksheet Functions	1	November 17th 05 01:58 AM

All times are GMT +1. The time now is 02:37 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us